package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "UNI_plat_third_id", columns = {"plat", "third_id"})
})
@_DDL_Table(name = "a_acc", simpleName = "", engine = MysqlDriver.InnoDB, comment = "账号")
public class _DDL_AAcc {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, comment = "用户id")
    private Long id;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, nullable = false, comment = "状态码 0 正常 1 锁定 2 销毁")
    private Integer state;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "des_time", type = SqlType.TIMESTAMP, comment = "销毁时间")
    private java.sql.Timestamp desTime;

    @_DDL_Column(name = "plat", type = SqlType.VARCHAR, size = 5, comment = "平台")
    private String plat;

    @_DDL_Column(name = "third_id", type = SqlType.INT, comment = "第三方id")
    private Integer thirdId;

}
